DATABASE PTMS

TABLES

Agencies
AgencyRateMappings
Clients
CustomReports
Destinations
Disabilities
Drivers
GISParameters
MiscellaneousCodes
MiscellaneousCodesValues
NewPas
NYCmn
NYParates
NYPriorApprovals
PaSharedRideCodes
ProcedureMatching
Providers
ReportOptions
RevenueCodes
Schedule
ScheduledTripSuspensions
SchedulingCapacityPerHour
ServiceRequests
States
SysProcLog
SystemParameters
Tripcodes
TripDistances
TripTransactions
Users
ValidServiceAuthorizations
Vehicles
VehicleServiceSummary
ZipCodes
Zones

VIEWS

TripData

STORED PROCEDURES

No stored procedures were found.

FUNCTIONS

No functions were found.

TRIGGERS

No triggers were found.

INDEXES

PK_Agencies
U_Agency
PK_AgencyRateMappings
U_AgencyFundingPurposeTripcode
PK_Clients
PK_CustomReports
U_Report
PK_Destinations
U_Destination
PK_Disabilities
U_Disability
PK_Drivers
U_Driver
PK_GISParameters
PK_MiscellaneousCodes
PK__MiscellaneousCod__2C3393D0
PK_NYCmn
PK_NYParates
U_Tripcode
PK_NYPriorApprovals
U_MedidConfirmno
PK_PaSharedRideCodes
U_AgencyFundingPurposeTripcode
PK__ProcedureMatchin__756D6ECB
PK_Providers
U_Provider
PK__ReportOptions__33D4B598
PK_RevenueCodes
U_CodetypeCode
PK_Schedule
PK_ScheduledTripSuspensions
U_ClientIDScheduleRecordNumber
PK_SchedulingCapacityPerHour
U_ScheduleHour
PK_ServiceRequests
PK__States__2E1BDC42
PK__SysProcLog__31EC6D26
PK_SystemParameters
PK_Tripcodes
U_Tripcode
PK_TripDistances
PK_TripTransactions
U_TransactionNumberTripdate
PK_Users
U_UserNumber
PK_ValidServiceAuthorizations
U_AgencyFundingPurposeTripcode
PK_Vehicles
U_Vehicle
PK_VehicleServiceSummary
PK__ZipCodes__300424B4
PK_Zones
U_Zone

FULL-TEXT CATALOGS

No full-text catalogs were found.